package com.shop.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shop.entity.MerchantGoods;
import com.shop.entity.MerchantMerchant;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * (MerchantMerchant)表数据库访问层
 *
 * @author makejava
 * @since 2020-11-21 10:02:40
 */
@Mapper
public interface MerchantMerchantMapper extends BaseMapper<MerchantMerchant> {
    @Select("SELECT * FROM `merchant_goods` WHERE goods_category_id=#{parseInt}")
    List<MerchantGoods> getGoodsListByCategoryId(int parseInt);

    @Select("select * FROM merchant_merchant where id=#{id}")
    MerchantMerchant getById(Integer id);
}
